<%@ page language="java" contentType="application/vnd.ms-excel,charset=utf-8"
	pageEncoding="utf-8"%>
<%@ page import="com.lm.survey.report.*"%> 
<%@ page import="com.lm.survey.model.*"%> 
<%@ page import="java.util.*"%><?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<% 
SurveyProject project = (SurveyProject)request.getAttribute("project");
List list = (List)request.getAttribute("list");

%>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <LastAuthor>lijiaz</LastAuthor>
  <Created>1996-10-14T23:33:28Z</Created>
  <LastSaved>2010-03-18T04:39:26Z</LastSaved>
  <Version>11.9999</Version>
 </DocumentProperties>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>9300</WindowHeight>
  <WindowWidth>15135</WindowWidth>
  <WindowTopX>120</WindowTopX>
  <WindowTopY>120</WindowTopY>
  <AcceptLabelsInFormulas/>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font x:Family="Swiss"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s21" ss:Name="超链接">
   <Font x:Family="Swiss" ss:Color="#0000FF" ss:Underline="Single"/>
  </Style>
  <Style ss:ID="s22">
   <Font ss:FontName="宋体" x:CharSet="134"/>
  </Style>
  <Style ss:ID="s26">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
  </Style>
  <Style ss:ID="s27">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Font ss:FontName="宋体" x:CharSet="134"/>
  </Style>
  <Style ss:ID="s31" ss:Parent="s21">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#0000FF" ss:Underline="Single"/>
  </Style>
  <Style ss:ID="s32">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Bold="1"/>
   <Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s33">
   <Font x:Family="Swiss" ss:Bold="1"/>
   <Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>
  </Style>
 </Styles>
 <Worksheet ss:Name="Sheet1">
  <Table ss:ExpandedColumnCount="7" ss:ExpandedRowCount="<%=(list.size()+50)%>" x:FullColumns="1"
   x:FullRows="1">
   <Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="129"/>
   <Column ss:StyleID="s26" ss:AutoFitWidth="0" ss:Width="96.75"/>
   <Column ss:StyleID="s26" ss:AutoFitWidth="0" ss:Width="72"/>
   <Column ss:StyleID="s26" ss:AutoFitWidth="0" ss:Width="92.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="92.25" ss:Span="1"/>
   <Row>
    <Cell ss:StyleID="s22"><Data ss:Type="String">项目名称</Data></Cell>
    <Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"> <Font
       html:Face="宋体" x:CharSet="134"><%=project.getName()%></Font></ss:Data></Cell>
   </Row>
   <Row>
    <Cell ss:StyleID="s22"><Data ss:Type="String">参与总数</Data></Cell>
    <Cell><Data ss:Type="Number"><%=list.size()%></Data></Cell>
   </Row>
   <Row>
    <Cell ss:StyleID="s22"/>
   </Row>
   <Row ss:StyleID="s33">
    <Cell ss:StyleID="s32"><Data ss:Type="String">姓名</Data></Cell>
    <Cell ss:StyleID="s32"><Data ss:Type="String">联系方式</Data></Cell>
    <Cell ss:StyleID="s32"><Data ss:Type="String">思维品质测验一</Data></Cell>
    <Cell ss:StyleID="s32"><Data ss:Type="String">思维品质测验一</Data></Cell>
    <Cell ss:StyleID="s32"><Data ss:Type="String">组三</Data></Cell>
   </Row>
   <Row>
    <Cell ss:StyleID="s22"/>
    <Cell ss:StyleID="s22"/>
    <Cell ss:StyleID="s27"/>
    <Cell ss:StyleID="s27"/>
    <Cell ss:StyleID="s27"/>
   </Row>
   
   <%
   SelfEQTestReportRecord rec = null;
    for(int i=0;i<list.size();i++){
    	rec = (SelfEQTestReportRecord)list.get(i);
   %>
   <Row ss:AutoFitHeight="0" ss:Height="20.25">
    <Cell ss:StyleID="s22"><Data ss:Type="String"><%=rec.getUserName()%></Data></Cell>
    <Cell ss:StyleID="s21"><Data ss:Type="String"><%=rec.getEmail() %></Data></Cell>
    <Cell ss:StyleID="s27"><Data ss:Type="Number"><%=rec.getScore()[0]%></Data></Cell>
    <Cell><Data ss:Type="Number"><%=rec.getScore()[1]%></Data></Cell>
    <Cell ss:StyleID="s31" ss:HRef="#"><Data ss:Type="String"></Data></Cell>
   </Row>
   <% 
    }
   %>
   
   
   <Row>
    <Cell ss:StyleID="s22"/>
    <Cell ss:StyleID="s21"/>
    <Cell ss:StyleID="s27"/>
   </Row>
   <Row>
    <Cell ss:Index="3" ss:StyleID="s27"/>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <Print>
    <ValidPrinterInfo/>
    <HorizontalResolution>600</HorizontalResolution>
    <VerticalResolution>600</VerticalResolution>
   </Print>
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>5</ActiveRow>
     <ActiveCol>4</ActiveCol>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
 <Worksheet ss:Name="Sheet2">
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
 <Worksheet ss:Name="Sheet3">
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>
	
	
